Dataset statistics
| Number of variables | 20 |
|---|---|
| Number of observations | 5630 |
| Missing cells | 1856 |
| Missing cells (%) | 1.6% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 879.8 KiB |
| Average record size in memory | 160.0 B |
Variable types
| Numeric | 11 |
|---|---|
| Categorical | 9 |
CustomerID is highly overall correlated with HourSpendOnApp and 3 other fields | High correlation |
CityTier is highly overall correlated with PreferredPaymentMode | High correlation |
PreferredPaymentMode is highly overall correlated with CityTier | High correlation |
HourSpendOnApp is highly overall correlated with CustomerID and 1 other fields | High correlation |
NumberOfDeviceRegistered is highly overall correlated with CustomerID and 1 other fields | High correlation |
PreferredOrderCat is highly overall correlated with CashbackAmount | High correlation |
SatisfactionScore is highly overall correlated with CustomerID | High correlation |
MaritalStatus is highly overall correlated with CustomerID | High correlation |
CouponUsed is highly overall correlated with OrderCount | High correlation |
OrderCount is highly overall correlated with CouponUsed | High correlation |
CashbackAmount is highly overall correlated with PreferredOrderCat | High correlation |
Tenure has 264 (4.7%) missing values | Missing |
WarehouseToHome has 251 (4.5%) missing values | Missing |
HourSpendOnApp has 255 (4.5%) missing values | Missing |
OrderAmountHikeFromlastYear has 265 (4.7%) missing values | Missing |
CouponUsed has 256 (4.5%) missing values | Missing |
OrderCount has 258 (4.6%) missing values | Missing |
DaySinceLastOrder has 307 (5.5%) missing values | Missing |
CustomerID is uniformly distributed | Uniform |
CustomerID has unique values | Unique |
Tenure has 508 (9.0%) zeros | Zeros |
CouponUsed has 1030 (18.3%) zeros | Zeros |
DaySinceLastOrder has 496 (8.8%) zeros | Zeros |
Reproduction
| Analysis started | 2024-07-09 02:24:41.847073 |
|---|---|
| Analysis finished | 2024-07-09 02:25:28.952761 |
| Duration | 47.11 seconds |
| Software version | ydata-profiling v4.8.3 |
| Download configuration | config.json |
CustomerID
Real number (ℝ)
HIGH CORRELATION UNIFORM UNIQUE
| Distinct | 5630 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 52815.5 |
| Minimum | 50001 |
|---|---|
| Maximum | 55630 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 44.1 KiB |
Quantile statistics
| Minimum | 50001 |
|---|---|
| 5-th percentile | 50282.45 |
| Q1 | 51408.25 |
| median | 52815.5 |
| Q3 | 54222.75 |
| 95-th percentile | 55348.55 |
| Maximum | 55630 |
| Range | 5629 |
| Interquartile range (IQR) | 2814.5 |
Descriptive statistics
| Standard deviation | 1625.3853 |
|---|---|
| Coefficient of variation (CV) | 0.030774779 |
| Kurtosis | -1.2 |
| Mean | 52815.5 |
| Median Absolute Deviation (MAD) | 1407.5 |
| Skewness | 0 |
| Sum | 2.9735126 × 108 |
| Variance | 2641877.5 |
| Monotonicity | Strictly increasing |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 50001 | 1 | < 0.1% |
| 53751 | 1 | < 0.1% |
| 53759 | 1 | < 0.1% |
| 53758 | 1 | < 0.1% |
| 53757 | 1 | < 0.1% |
| 53756 | 1 | < 0.1% |
| 53755 | 1 | < 0.1% |
| 53754 | 1 | < 0.1% |
| 53753 | 1 | < 0.1% |
| 53752 | 1 | < 0.1% |
| Other values (5620) | 5620 |
| Value | Count | Frequency (%) |
| 50001 | 1 | |
| 50002 | 1 | |
| 50003 | 1 | |
| 50004 | 1 | |
| 50005 | 1 | |
| 50006 | 1 | |
| 50007 | 1 | |
| 50008 | 1 | |
| 50009 | 1 | |
| 50010 | 1 |
| Value | Count | Frequency (%) |
| 55630 | 1 | |
| 55629 | 1 | |
| 55628 | 1 | |
| 55627 | 1 | |
| 55626 | 1 | |
| 55625 | 1 | |
| 55624 | 1 | |
| 55623 | 1 | |
| 55622 | 1 | |
| 55621 | 1 |
Churn
Categorical
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 44.1 KiB |
| 0 | |
|---|---|
| 1 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 5630 |
|---|---|
| Distinct characters | 2 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 1 |
|---|---|
| 2nd row | 1 |
| 3rd row | 1 |
| 4th row | 1 |
| 5th row | 1 |
Common Values
| Value | Count | Frequency (%) |
| 0 | 4682 | |
| 1 | 948 | 16.8% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| 0 | 4682 | |
| 1 | 948 | 16.8% |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 4682 | |
| 1 | 948 | 16.8% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 5630 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 0 | 4682 | |
| 1 | 948 | 16.8% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 5630 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 0 | 4682 | |
| 1 | 948 | 16.8% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 5630 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 0 | 4682 | |
| 1 | 948 | 16.8% |
Tenure
Real number (ℝ)
MISSING ZEROS
| Distinct | 36 |
|---|---|
| Distinct (%) | 0.7% |
| Missing | 264 |
| Missing (%) | 4.7% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 10.189899 |
| Minimum | 0 |
|---|---|
| Maximum | 61 |
| Zeros | 508 |
| Zeros (%) | 9.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 44.1 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 2 |
| median | 9 |
| Q3 | 16 |
| 95-th percentile | 27 |
| Maximum | 61 |
| Range | 61 |
| Interquartile range (IQR) | 14 |
Descriptive statistics
| Standard deviation | 8.557241 |
|---|---|
| Coefficient of variation (CV) | 0.83977679 |
| Kurtosis | -0.0073694695 |
| Mean | 10.189899 |
| Median Absolute Deviation (MAD) | 7 |
| Skewness | 0.73651338 |
| Sum | 54679 |
| Variance | 73.226373 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=36)
| Value | Count | Frequency (%) |
| 1 | 690 | 12.3% |
| 0 | 508 | 9.0% |
| 8 | 263 | 4.7% |
| 9 | 247 | 4.4% |
| 7 | 221 | 3.9% |
| 10 | 213 | 3.8% |
| 5 | 204 | 3.6% |
| 4 | 203 | 3.6% |
| 3 | 195 | 3.5% |
| 11 | 194 | 3.4% |
| Other values (26) | 2428 | |
| (Missing) | 264 | 4.7% |
| Value | Count | Frequency (%) |
| 0 | 508 | |
| 1 | 690 | |
| 2 | 167 | 3.0% |
| 3 | 195 | 3.5% |
| 4 | 203 | 3.6% |
| 5 | 204 | 3.6% |
| 6 | 183 | 3.3% |
| 7 | 221 | 3.9% |
| 8 | 263 | 4.7% |
| 9 | 247 | 4.4% |
| Value | Count | Frequency (%) |
| 61 | 1 | < 0.1% |
| 60 | 1 | < 0.1% |
| 51 | 1 | < 0.1% |
| 50 | 1 | < 0.1% |
| 31 | 49 | |
| 30 | 66 | |
| 29 | 55 | |
| 28 | 70 | |
| 27 | 66 | |
| 26 | 60 |
PreferredLoginDevice
Categorical
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 44.1 KiB |
| Phone | |
|---|---|
| Computer |
Length
| Max length | 8 |
|---|---|
| Median length | 5 |
| Mean length | 5.8706927 |
| Min length | 5 |
Characters and Unicode
| Total characters | 33052 |
|---|---|
| Distinct characters | 11 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Phone |
|---|---|
| 2nd row | Phone |
| 3rd row | Phone |
| 4th row | Phone |
| 5th row | Phone |
Common Values
| Value | Count | Frequency (%) |
| Phone | 3996 | |
| Computer | 1634 |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| phone | 3996 | |
| computer | 1634 |
Most occurring characters
| Value | Count | Frequency (%) |
| o | 5630 | |
| e | 5630 | |
| P | 3996 | |
| h | 3996 | |
| n | 3996 | |
| C | 1634 | 4.9% |
| m | 1634 | 4.9% |
| p | 1634 | 4.9% |
| u | 1634 | 4.9% |
| t | 1634 | 4.9% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 33052 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| o | 5630 | |
| e | 5630 | |
| P | 3996 | |
| h | 3996 | |
| n | 3996 | |
| C | 1634 | 4.9% |
| m | 1634 | 4.9% |
| p | 1634 | 4.9% |
| u | 1634 | 4.9% |
| t | 1634 | 4.9% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 33052 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| o | 5630 | |
| e | 5630 | |
| P | 3996 | |
| h | 3996 | |
| n | 3996 | |
| C | 1634 | 4.9% |
| m | 1634 | 4.9% |
| p | 1634 | 4.9% |
| u | 1634 | 4.9% |
| t | 1634 | 4.9% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 33052 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| o | 5630 | |
| e | 5630 | |
| P | 3996 | |
| h | 3996 | |
| n | 3996 | |
| C | 1634 | 4.9% |
| m | 1634 | 4.9% |
| p | 1634 | 4.9% |
| u | 1634 | 4.9% |
| t | 1634 | 4.9% |
CityTier
Categorical
HIGH CORRELATION
| Distinct | 3 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 44.1 KiB |
| 1 | |
|---|---|
| 3 | |
| 2 | 242 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 5630 |
|---|---|
| Distinct characters | 3 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 3 |
|---|---|
| 2nd row | 1 |
| 3rd row | 1 |
| 4th row | 3 |
| 5th row | 1 |
Common Values
| Value | Count | Frequency (%) |
| 1 | 3666 | |
| 3 | 1722 | |
| 2 | 242 | 4.3% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| 1 | 3666 | |
| 3 | 1722 | |
| 2 | 242 | 4.3% |
Most occurring characters
| Value | Count | Frequency (%) |
| 1 | 3666 | |
| 3 | 1722 | |
| 2 | 242 | 4.3% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 5630 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 1 | 3666 | |
| 3 | 1722 | |
| 2 | 242 | 4.3% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 5630 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 1 | 3666 | |
| 3 | 1722 | |
| 2 | 242 | 4.3% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 5630 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 1 | 3666 | |
| 3 | 1722 | |
| 2 | 242 | 4.3% |
WarehouseToHome
Real number (ℝ)
MISSING
| Distinct | 34 |
|---|---|
| Distinct (%) | 0.6% |
| Missing | 251 |
| Missing (%) | 4.5% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 15.639896 |
| Minimum | 5 |
|---|---|
| Maximum | 127 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 44.1 KiB |
Quantile statistics
| Minimum | 5 |
|---|---|
| 5-th percentile | 6 |
| Q1 | 9 |
| median | 14 |
| Q3 | 20 |
| 95-th percentile | 33 |
| Maximum | 127 |
| Range | 122 |
| Interquartile range (IQR) | 11 |
Descriptive statistics
| Standard deviation | 8.5314752 |
|---|---|
| Coefficient of variation (CV) | 0.54549437 |
| Kurtosis | 9.9869304 |
| Mean | 15.639896 |
| Median Absolute Deviation (MAD) | 5 |
| Skewness | 1.6191537 |
| Sum | 84127 |
| Variance | 72.786069 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=34)
| Value | Count | Frequency (%) |
| 9 | 559 | 9.9% |
| 8 | 444 | 7.9% |
| 7 | 389 | 6.9% |
| 16 | 322 | 5.7% |
| 14 | 299 | 5.3% |
| 6 | 295 | 5.2% |
| 15 | 288 | 5.1% |
| 10 | 274 | 4.9% |
| 13 | 249 | 4.4% |
| 11 | 233 | 4.1% |
| Other values (24) | 2027 | |
| (Missing) | 251 | 4.5% |
| Value | Count | Frequency (%) |
| 5 | 8 | 0.1% |
| 6 | 295 | |
| 7 | 389 | |
| 8 | 444 | |
| 9 | 559 | |
| 10 | 274 | |
| 11 | 233 | |
| 12 | 221 | 3.9% |
| 13 | 249 | |
| 14 | 299 |
| Value | Count | Frequency (%) |
| 127 | 1 | < 0.1% |
| 126 | 1 | < 0.1% |
| 36 | 51 | |
| 35 | 93 | |
| 34 | 63 | |
| 33 | 67 | |
| 32 | 94 | |
| 31 | 101 | |
| 30 | 94 | |
| 29 | 81 |
PreferredPaymentMode
Categorical
HIGH CORRELATION
| Distinct | 5 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 44.1 KiB |
| Debit Card | |
|---|---|
| Credit Card | |
| E wallet | |
| Cash on Delivery | |
| UPI |
Length
| Max length | 16 |
|---|---|
| Median length | 11 |
| Mean length | 10.130018 |
| Min length | 3 |
Characters and Unicode
| Total characters | 57032 |
|---|---|
| Distinct characters | 22 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Debit Card |
|---|---|
| 2nd row | UPI |
| 3rd row | Debit Card |
| 4th row | Debit Card |
| 5th row | Credit Card |
Common Values
| Value | Count | Frequency (%) |
| Debit Card | 2314 | |
| Credit Card | 1774 | |
| E wallet | 614 | 10.9% |
| Cash on Delivery | 514 | 9.1% |
| UPI | 414 | 7.4% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| card | 4088 | |
| debit | 2314 | |
| credit | 1774 | |
| e | 614 | 5.4% |
| wallet | 614 | 5.4% |
| cash | 514 | 4.5% |
| on | 514 | 4.5% |
| delivery | 514 | 4.5% |
| upi | 414 | 3.6% |
Most occurring characters
| Value | Count | Frequency (%) |
| C | 6376 | |
| r | 6376 | |
| d | 5862 | |
| e | 5730 | |
| 5730 | ||
| a | 5216 | |
| t | 4702 | |
| i | 4602 | |
| D | 2828 | 5.0% |
| b | 2314 | 4.1% |
| Other values (12) | 7296 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 57032 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| C | 6376 | |
| r | 6376 | |
| d | 5862 | |
| e | 5730 | |
| 5730 | ||
| a | 5216 | |
| t | 4702 | |
| i | 4602 | |
| D | 2828 | 5.0% |
| b | 2314 | 4.1% |
| Other values (12) | 7296 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 57032 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| C | 6376 | |
| r | 6376 | |
| d | 5862 | |
| e | 5730 | |
| 5730 | ||
| a | 5216 | |
| t | 4702 | |
| i | 4602 | |
| D | 2828 | 5.0% |
| b | 2314 | 4.1% |
| Other values (12) | 7296 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 57032 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| C | 6376 | |
| r | 6376 | |
| d | 5862 | |
| e | 5730 | |
| 5730 | ||
| a | 5216 | |
| t | 4702 | |
| i | 4602 | |
| D | 2828 | 5.0% |
| b | 2314 | 4.1% |
| Other values (12) | 7296 |
Gender
Categorical
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 44.1 KiB |
| Male | |
|---|---|
| Female |
Length
| Max length | 6 |
|---|---|
| Median length | 4 |
| Mean length | 4.7978686 |
| Min length | 4 |
Characters and Unicode
| Total characters | 27012 |
|---|---|
| Distinct characters | 6 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Female |
|---|---|
| 2nd row | Male |
| 3rd row | Male |
| 4th row | Male |
| 5th row | Male |
Common Values
| Value | Count | Frequency (%) |
| Male | 3384 | |
| Female | 2246 |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| male | 3384 | |
| female | 2246 |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 7876 | |
| a | 5630 | |
| l | 5630 | |
| M | 3384 | |
| F | 2246 | 8.3% |
| m | 2246 | 8.3% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 27012 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| e | 7876 | |
| a | 5630 | |
| l | 5630 | |
| M | 3384 | |
| F | 2246 | 8.3% |
| m | 2246 | 8.3% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 27012 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| e | 7876 | |
| a | 5630 | |
| l | 5630 | |
| M | 3384 | |
| F | 2246 | 8.3% |
| m | 2246 | 8.3% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 27012 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| e | 7876 | |
| a | 5630 | |
| l | 5630 | |
| M | 3384 | |
| F | 2246 | 8.3% |
| m | 2246 | 8.3% |
HourSpendOnApp
Real number (ℝ)
HIGH CORRELATION MISSING
| Distinct | 6 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 255 |
| Missing (%) | 4.5% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2.9315349 |
| Minimum | 0 |
|---|---|
| Maximum | 5 |
| Zeros | 3 |
| Zeros (%) | 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 44.1 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 2 |
| Q1 | 2 |
| median | 3 |
| Q3 | 3 |
| 95-th percentile | 4 |
| Maximum | 5 |
| Range | 5 |
| Interquartile range (IQR) | 1 |
Descriptive statistics
| Standard deviation | 0.72192585 |
|---|---|
| Coefficient of variation (CV) | 0.24626207 |
| Kurtosis | -0.66707614 |
| Mean | 2.9315349 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | -0.027212622 |
| Sum | 15757 |
| Variance | 0.52117693 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=6)
| Value | Count | Frequency (%) |
| 3 | 2687 | |
| 2 | 1471 | |
| 4 | 1176 | |
| 1 | 35 | 0.6% |
| 0 | 3 | 0.1% |
| 5 | 3 | 0.1% |
| (Missing) | 255 | 4.5% |
| Value | Count | Frequency (%) |
| 0 | 3 | 0.1% |
| 1 | 35 | 0.6% |
| 2 | 1471 | |
| 3 | 2687 | |
| 4 | 1176 | |
| 5 | 3 | 0.1% |
| Value | Count | Frequency (%) |
| 5 | 3 | 0.1% |
| 4 | 1176 | |
| 3 | 2687 | |
| 2 | 1471 | |
| 1 | 35 | 0.6% |
| 0 | 3 | 0.1% |
NumberOfDeviceRegistered
Real number (ℝ)
HIGH CORRELATION
| Distinct | 6 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3.6889876 |
| Minimum | 1 |
|---|---|
| Maximum | 6 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 44.1 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 2 |
| Q1 | 3 |
| median | 4 |
| Q3 | 4 |
| 95-th percentile | 5 |
| Maximum | 6 |
| Range | 5 |
| Interquartile range (IQR) | 1 |
Descriptive statistics
| Standard deviation | 1.0239985 |
|---|---|
| Coefficient of variation (CV) | 0.27758253 |
| Kurtosis | 0.58284873 |
| Mean | 3.6889876 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | -0.39696864 |
| Sum | 20769 |
| Variance | 1.048573 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=6)
| Value | Count | Frequency (%) |
| 4 | 2377 | |
| 3 | 1699 | |
| 5 | 881 | 15.6% |
| 2 | 276 | 4.9% |
| 1 | 235 | 4.2% |
| 6 | 162 | 2.9% |
| Value | Count | Frequency (%) |
| 1 | 235 | 4.2% |
| 2 | 276 | 4.9% |
| 3 | 1699 | |
| 4 | 2377 | |
| 5 | 881 | 15.6% |
| 6 | 162 | 2.9% |
| Value | Count | Frequency (%) |
| 6 | 162 | 2.9% |
| 5 | 881 | 15.6% |
| 4 | 2377 | |
| 3 | 1699 | |
| 2 | 276 | 4.9% |
| 1 | 235 | 4.2% |
PreferredOrderCat
Categorical
HIGH CORRELATION
| Distinct | 5 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 44.1 KiB |
| Phone | |
|---|---|
| Laptop & Accessory | |
| Fashion | |
| Grocery | |
| Others |
Length
| Max length | 18 |
|---|---|
| Median length | 7 |
| Mean length | 10.219538 |
| Min length | 5 |
Characters and Unicode
| Total characters | 57536 |
|---|---|
| Distinct characters | 20 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Laptop & Accessory |
|---|---|
| 2nd row | Phone |
| 3rd row | Phone |
| 4th row | Laptop & Accessory |
| 5th row | Phone |
Common Values
| Value | Count | Frequency (%) |
| Phone | 2080 | |
| Laptop & Accessory | 2050 | |
| Fashion | 826 | 14.7% |
| Grocery | 410 | 7.3% |
| Others | 264 | 4.7% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| phone | 2080 | |
| laptop | 2050 | |
| 2050 | ||
| accessory | 2050 | |
| fashion | 826 | 8.5% |
| grocery | 410 | 4.2% |
| others | 264 | 2.7% |
Most occurring characters
| Value | Count | Frequency (%) |
| o | 7416 | |
| s | 5190 | 9.0% |
| e | 4804 | 8.3% |
| c | 4510 | 7.8% |
| p | 4100 | 7.1% |
| 4100 | 7.1% | |
| h | 3170 | 5.5% |
| r | 3134 | 5.4% |
| n | 2906 | 5.1% |
| a | 2876 | 5.0% |
| Other values (10) | 15330 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 57536 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| o | 7416 | |
| s | 5190 | 9.0% |
| e | 4804 | 8.3% |
| c | 4510 | 7.8% |
| p | 4100 | 7.1% |
| 4100 | 7.1% | |
| h | 3170 | 5.5% |
| r | 3134 | 5.4% |
| n | 2906 | 5.1% |
| a | 2876 | 5.0% |
| Other values (10) | 15330 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 57536 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| o | 7416 | |
| s | 5190 | 9.0% |
| e | 4804 | 8.3% |
| c | 4510 | 7.8% |
| p | 4100 | 7.1% |
| 4100 | 7.1% | |
| h | 3170 | 5.5% |
| r | 3134 | 5.4% |
| n | 2906 | 5.1% |
| a | 2876 | 5.0% |
| Other values (10) | 15330 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 57536 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| o | 7416 | |
| s | 5190 | 9.0% |
| e | 4804 | 8.3% |
| c | 4510 | 7.8% |
| p | 4100 | 7.1% |
| 4100 | 7.1% | |
| h | 3170 | 5.5% |
| r | 3134 | 5.4% |
| n | 2906 | 5.1% |
| a | 2876 | 5.0% |
| Other values (10) | 15330 |
SatisfactionScore
Categorical
HIGH CORRELATION
| Distinct | 5 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 44.1 KiB |
| 3 | |
|---|---|
| 1 | |
| 5 | |
| 4 | |
| 2 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 5630 |
|---|---|
| Distinct characters | 5 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 2 |
|---|---|
| 2nd row | 3 |
| 3rd row | 3 |
| 4th row | 5 |
| 5th row | 5 |
Common Values
| Value | Count | Frequency (%) |
| 3 | 1698 | |
| 1 | 1164 | |
| 5 | 1108 | |
| 4 | 1074 | |
| 2 | 586 | 10.4% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| 3 | 1698 | |
| 1 | 1164 | |
| 5 | 1108 | |
| 4 | 1074 | |
| 2 | 586 | 10.4% |
Most occurring characters
| Value | Count | Frequency (%) |
| 3 | 1698 | |
| 1 | 1164 | |
| 5 | 1108 | |
| 4 | 1074 | |
| 2 | 586 | 10.4% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 5630 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 3 | 1698 | |
| 1 | 1164 | |
| 5 | 1108 | |
| 4 | 1074 | |
| 2 | 586 | 10.4% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 5630 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 3 | 1698 | |
| 1 | 1164 | |
| 5 | 1108 | |
| 4 | 1074 | |
| 2 | 586 | 10.4% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 5630 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 3 | 1698 | |
| 1 | 1164 | |
| 5 | 1108 | |
| 4 | 1074 | |
| 2 | 586 | 10.4% |
MaritalStatus
Categorical
HIGH CORRELATION
| Distinct | 3 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 44.1 KiB |
| Married | |
|---|---|
| Single | |
| Divorced |
Length
| Max length | 8 |
|---|---|
| Median length | 7 |
| Mean length | 6.8316163 |
| Min length | 6 |
Characters and Unicode
| Total characters | 38462 |
|---|---|
| Distinct characters | 14 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Single |
|---|---|
| 2nd row | Single |
| 3rd row | Single |
| 4th row | Single |
| 5th row | Single |
Common Values
| Value | Count | Frequency (%) |
| Married | 2986 | |
| Single | 1796 | |
| Divorced | 848 | 15.1% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| married | 2986 | |
| single | 1796 | |
| divorced | 848 | 15.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| r | 6820 | |
| i | 5630 | |
| e | 5630 | |
| d | 3834 | |
| M | 2986 | |
| a | 2986 | |
| S | 1796 | 4.7% |
| n | 1796 | 4.7% |
| g | 1796 | 4.7% |
| l | 1796 | 4.7% |
| Other values (4) | 3392 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 38462 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| r | 6820 | |
| i | 5630 | |
| e | 5630 | |
| d | 3834 | |
| M | 2986 | |
| a | 2986 | |
| S | 1796 | 4.7% |
| n | 1796 | 4.7% |
| g | 1796 | 4.7% |
| l | 1796 | 4.7% |
| Other values (4) | 3392 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 38462 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| r | 6820 | |
| i | 5630 | |
| e | 5630 | |
| d | 3834 | |
| M | 2986 | |
| a | 2986 | |
| S | 1796 | 4.7% |
| n | 1796 | 4.7% |
| g | 1796 | 4.7% |
| l | 1796 | 4.7% |
| Other values (4) | 3392 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 38462 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| r | 6820 | |
| i | 5630 | |
| e | 5630 | |
| d | 3834 | |
| M | 2986 | |
| a | 2986 | |
| S | 1796 | 4.7% |
| n | 1796 | 4.7% |
| g | 1796 | 4.7% |
| l | 1796 | 4.7% |
| Other values (4) | 3392 |
NumberOfAddress
Real number (ℝ)
| Distinct | 15 |
|---|---|
| Distinct (%) | 0.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 4.214032 |
| Minimum | 1 |
|---|---|
| Maximum | 22 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 44.1 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 2 |
| median | 3 |
| Q3 | 6 |
| 95-th percentile | 10 |
| Maximum | 22 |
| Range | 21 |
| Interquartile range (IQR) | 4 |
Descriptive statistics
| Standard deviation | 2.5835855 |
|---|---|
| Coefficient of variation (CV) | 0.6130911 |
| Kurtosis | 0.95922927 |
| Mean | 4.214032 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | 1.0886394 |
| Sum | 23725 |
| Variance | 6.6749141 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=15)
| Value | Count | Frequency (%) |
| 2 | 1369 | |
| 3 | 1278 | |
| 4 | 588 | |
| 5 | 571 | |
| 6 | 382 | 6.8% |
| 1 | 371 | 6.6% |
| 8 | 280 | 5.0% |
| 7 | 256 | 4.5% |
| 9 | 239 | 4.2% |
| 10 | 194 | 3.4% |
| Other values (5) | 102 | 1.8% |
| Value | Count | Frequency (%) |
| 1 | 371 | 6.6% |
| 2 | 1369 | |
| 3 | 1278 | |
| 4 | 588 | |
| 5 | 571 | |
| 6 | 382 | 6.8% |
| 7 | 256 | 4.5% |
| 8 | 280 | 5.0% |
| 9 | 239 | 4.2% |
| 10 | 194 | 3.4% |
| Value | Count | Frequency (%) |
| 22 | 1 | < 0.1% |
| 21 | 1 | < 0.1% |
| 20 | 1 | < 0.1% |
| 19 | 1 | < 0.1% |
| 11 | 98 | 1.7% |
| 10 | 194 | |
| 9 | 239 | |
| 8 | 280 | |
| 7 | 256 | |
| 6 | 382 |
Complain
Categorical
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 44.1 KiB |
| 0 | |
|---|---|
| 1 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 5630 |
|---|---|
| Distinct characters | 2 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 1 |
|---|---|
| 2nd row | 1 |
| 3rd row | 1 |
| 4th row | 0 |
| 5th row | 0 |
Common Values
| Value | Count | Frequency (%) |
| 0 | 4026 | |
| 1 | 1604 | 28.5% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| 0 | 4026 | |
| 1 | 1604 | 28.5% |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 4026 | |
| 1 | 1604 | 28.5% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 5630 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 0 | 4026 | |
| 1 | 1604 | 28.5% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 5630 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 0 | 4026 | |
| 1 | 1604 | 28.5% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 5630 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 0 | 4026 | |
| 1 | 1604 | 28.5% |
OrderAmountHikeFromlastYear
Real number (ℝ)
MISSING
| Distinct | 16 |
|---|---|
| Distinct (%) | 0.3% |
| Missing | 265 |
| Missing (%) | 4.7% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 15.707922 |
| Minimum | 11 |
|---|---|
| Maximum | 26 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 44.1 KiB |
Quantile statistics
| Minimum | 11 |
|---|---|
| 5-th percentile | 11 |
| Q1 | 13 |
| median | 15 |
| Q3 | 18 |
| 95-th percentile | 23 |
| Maximum | 26 |
| Range | 15 |
| Interquartile range (IQR) | 5 |
Descriptive statistics
| Standard deviation | 3.6754855 |
|---|---|
| Coefficient of variation (CV) | 0.23398929 |
| Kurtosis | -0.28038119 |
| Mean | 15.707922 |
| Median Absolute Deviation (MAD) | 3 |
| Skewness | 0.79078536 |
| Sum | 84273 |
| Variance | 13.509193 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=16)
| Value | Count | Frequency (%) |
| 14 | 750 | |
| 13 | 741 | |
| 12 | 728 | |
| 15 | 542 | |
| 11 | 391 | |
| 16 | 333 | |
| 18 | 321 | |
| 19 | 311 | |
| 17 | 297 | 5.3% |
| 20 | 243 | 4.3% |
| Other values (6) | 708 | |
| (Missing) | 265 | 4.7% |
| Value | Count | Frequency (%) |
| 11 | 391 | |
| 12 | 728 | |
| 13 | 741 | |
| 14 | 750 | |
| 15 | 542 | |
| 16 | 333 | |
| 17 | 297 | 5.3% |
| 18 | 321 | |
| 19 | 311 | |
| 20 | 243 | 4.3% |
| Value | Count | Frequency (%) |
| 26 | 33 | 0.6% |
| 25 | 73 | 1.3% |
| 24 | 84 | 1.5% |
| 23 | 144 | |
| 22 | 184 | |
| 21 | 190 | |
| 20 | 243 | |
| 19 | 311 | |
| 18 | 321 | |
| 17 | 297 |
CouponUsed
Real number (ℝ)
HIGH CORRELATION MISSING ZEROS
| Distinct | 17 |
|---|---|
| Distinct (%) | 0.3% |
| Missing | 256 |
| Missing (%) | 4.5% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1.7510234 |
| Minimum | 0 |
|---|---|
| Maximum | 16 |
| Zeros | 1030 |
| Zeros (%) | 18.3% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 44.1 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 1 |
| median | 1 |
| Q3 | 2 |
| 95-th percentile | 6 |
| Maximum | 16 |
| Range | 16 |
| Interquartile range (IQR) | 1 |
Descriptive statistics
| Standard deviation | 1.8946214 |
|---|---|
| Coefficient of variation (CV) | 1.082008 |
| Kurtosis | 9.1322812 |
| Mean | 1.7510234 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | 2.5456526 |
| Sum | 9410 |
| Variance | 3.5895904 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=17)
| Value | Count | Frequency (%) |
| 1 | 2105 | |
| 2 | 1283 | |
| 0 | 1030 | |
| 3 | 327 | 5.8% |
| 4 | 197 | 3.5% |
| 5 | 129 | 2.3% |
| 6 | 108 | 1.9% |
| 7 | 89 | 1.6% |
| 8 | 42 | 0.7% |
| 10 | 14 | 0.2% |
| Other values (7) | 50 | 0.9% |
| (Missing) | 256 | 4.5% |
| Value | Count | Frequency (%) |
| 0 | 1030 | |
| 1 | 2105 | |
| 2 | 1283 | |
| 3 | 327 | 5.8% |
| 4 | 197 | 3.5% |
| 5 | 129 | 2.3% |
| 6 | 108 | 1.9% |
| 7 | 89 | 1.6% |
| 8 | 42 | 0.7% |
| 9 | 13 | 0.2% |
| Value | Count | Frequency (%) |
| 16 | 2 | < 0.1% |
| 15 | 1 | < 0.1% |
| 14 | 5 | 0.1% |
| 13 | 8 | 0.1% |
| 12 | 9 | 0.2% |
| 11 | 12 | 0.2% |
| 10 | 14 | 0.2% |
| 9 | 13 | 0.2% |
| 8 | 42 | |
| 7 | 89 |
OrderCount
Real number (ℝ)
HIGH CORRELATION MISSING
| Distinct | 16 |
|---|---|
| Distinct (%) | 0.3% |
| Missing | 258 |
| Missing (%) | 4.6% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3.0080045 |
| Minimum | 1 |
|---|---|
| Maximum | 16 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 44.1 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 1 |
| median | 2 |
| Q3 | 3 |
| 95-th percentile | 9 |
| Maximum | 16 |
| Range | 15 |
| Interquartile range (IQR) | 2 |
Descriptive statistics
| Standard deviation | 2.9396795 |
|---|---|
| Coefficient of variation (CV) | 0.97728563 |
| Kurtosis | 4.7184661 |
| Mean | 3.0080045 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | 2.1964141 |
| Sum | 16159 |
| Variance | 8.6417158 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=16)
| Value | Count | Frequency (%) |
| 2 | 2025 | |
| 1 | 1751 | |
| 3 | 371 | 6.6% |
| 7 | 206 | 3.7% |
| 4 | 204 | 3.6% |
| 5 | 181 | 3.2% |
| 8 | 172 | 3.1% |
| 6 | 137 | 2.4% |
| 9 | 62 | 1.1% |
| 12 | 54 | 1.0% |
| Other values (6) | 209 | 3.7% |
| (Missing) | 258 | 4.6% |
| Value | Count | Frequency (%) |
| 1 | 1751 | |
| 2 | 2025 | |
| 3 | 371 | 6.6% |
| 4 | 204 | 3.6% |
| 5 | 181 | 3.2% |
| 6 | 137 | 2.4% |
| 7 | 206 | 3.7% |
| 8 | 172 | 3.1% |
| 9 | 62 | 1.1% |
| 10 | 36 | 0.6% |
| Value | Count | Frequency (%) |
| 16 | 23 | 0.4% |
| 15 | 33 | 0.6% |
| 14 | 36 | 0.6% |
| 13 | 30 | 0.5% |
| 12 | 54 | 1.0% |
| 11 | 51 | 0.9% |
| 10 | 36 | 0.6% |
| 9 | 62 | 1.1% |
| 8 | 172 | |
| 7 | 206 |
DaySinceLastOrder
Real number (ℝ)
MISSING ZEROS
| Distinct | 22 |
|---|---|
| Distinct (%) | 0.4% |
| Missing | 307 |
| Missing (%) | 5.5% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 4.5434905 |
| Minimum | 0 |
|---|---|
| Maximum | 46 |
| Zeros | 496 |
| Zeros (%) | 8.8% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 44.1 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 2 |
| median | 3 |
| Q3 | 7 |
| 95-th percentile | 11 |
| Maximum | 46 |
| Range | 46 |
| Interquartile range (IQR) | 5 |
Descriptive statistics
| Standard deviation | 3.6544332 |
|---|---|
| Coefficient of variation (CV) | 0.80432284 |
| Kurtosis | 4.0239643 |
| Mean | 4.5434905 |
| Median Absolute Deviation (MAD) | 2 |
| Skewness | 1.1909995 |
| Sum | 24185 |
| Variance | 13.354882 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=22)
| Value | Count | Frequency (%) |
| 3 | 900 | |
| 2 | 792 | |
| 1 | 614 | |
| 8 | 538 | |
| 0 | 496 | |
| 7 | 447 | |
| 4 | 431 | |
| 9 | 299 | 5.3% |
| 5 | 228 | 4.0% |
| 10 | 157 | 2.8% |
| Other values (12) | 421 | |
| (Missing) | 307 | 5.5% |
| Value | Count | Frequency (%) |
| 0 | 496 | |
| 1 | 614 | |
| 2 | 792 | |
| 3 | 900 | |
| 4 | 431 | |
| 5 | 228 | 4.0% |
| 6 | 113 | 2.0% |
| 7 | 447 | |
| 8 | 538 | |
| 9 | 299 | 5.3% |
| Value | Count | Frequency (%) |
| 46 | 1 | < 0.1% |
| 31 | 1 | < 0.1% |
| 30 | 1 | < 0.1% |
| 18 | 10 | 0.2% |
| 17 | 17 | 0.3% |
| 16 | 13 | 0.2% |
| 15 | 19 | 0.3% |
| 14 | 35 | |
| 13 | 51 | |
| 12 | 69 |
CashbackAmount
Real number (ℝ)
HIGH CORRELATION
| Distinct | 2586 |
|---|---|
| Distinct (%) | 45.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 177.22303 |
| Minimum | 0 |
|---|---|
| Maximum | 324.99 |
| Zeros | 4 |
| Zeros (%) | 0.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 44.1 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 123.0335 |
| Q1 | 145.77 |
| median | 163.28 |
| Q3 | 196.3925 |
| 95-th percentile | 291.9385 |
| Maximum | 324.99 |
| Range | 324.99 |
| Interquartile range (IQR) | 50.6225 |
Descriptive statistics
| Standard deviation | 49.207036 |
|---|---|
| Coefficient of variation (CV) | 0.27765599 |
| Kurtosis | 0.97450522 |
| Mean | 177.22303 |
| Median Absolute Deviation (MAD) | 23.035 |
| Skewness | 1.1498457 |
| Sum | 997765.66 |
| Variance | 2421.3324 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 123.42 | 8 | 0.1% |
| 149.36 | 8 | 0.1% |
| 148.42 | 8 | 0.1% |
| 188.47 | 7 | 0.1% |
| 154.73 | 7 | 0.1% |
| 180.62 | 6 | 0.1% |
| 126.1 | 6 | 0.1% |
| 125.59 | 6 | 0.1% |
| 153.04 | 6 | 0.1% |
| 146.27 | 6 | 0.1% |
| Other values (2576) | 5562 |
| Value | Count | Frequency (%) |
| 0 | 4 | |
| 12 | 1 | < 0.1% |
| 25 | 4 | |
| 37 | 1 | < 0.1% |
| 56 | 1 | < 0.1% |
| 81 | 1 | < 0.1% |
| 110.09 | 2 | |
| 110.51 | 2 | |
| 110.52 | 2 | |
| 110.81 | 2 |
| Value | Count | Frequency (%) |
| 324.99 | 2 | |
| 324.73 | 2 | |
| 324.43 | 2 | |
| 324.26 | 2 | |
| 323.59 | 2 | |
| 323.47 | 2 | |
| 323.45 | 2 | |
| 323.33 | 2 | |
| 322.4 | 2 | |
| 322.17 | 2 |
| CustomerID | Churn | Tenure | PreferredLoginDevice | CityTier | WarehouseToHome | PreferredPaymentMode | Gender | HourSpendOnApp | NumberOfDeviceRegistered | PreferredOrderCat | SatisfactionScore | MaritalStatus | NumberOfAddress | Complain | OrderAmountHikeFromlastYear | CouponUsed | OrderCount | DaySinceLastOrder | CashbackAmount | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| CustomerID | 1.000 | 0.000 | 0.060 | 0.000 | 0.000 | 0.000 | 0.000 | 0.000 | 0.529 | 0.544 | 0.000 | 0.543 | 0.550 | 0.089 | 0.000 | 0.187 | 0.421 | 0.151 | 0.059 | 0.441 |
| Churn | 0.000 | 1.000 | 0.481 | 0.077 | 0.050 | 0.128 | 0.075 | 0.040 | 0.040 | 0.162 | 0.184 | 0.088 | 0.110 | 0.079 | 0.382 | 0.086 | 0.026 | 0.076 | 0.183 | 0.247 |
| Tenure | 0.060 | 0.481 | 1.000 | 0.072 | 0.084 | 0.105 | 0.068 | 0.073 | 0.083 | 0.079 | 0.427 | 0.060 | 0.135 | 0.261 | 0.070 | 0.110 | 0.104 | 0.193 | 0.178 | 0.383 |
| PreferredLoginDevice | 0.000 | 0.077 | 0.072 | 1.000 | 0.000 | 0.060 | 0.030 | 0.012 | 0.037 | 0.019 | 0.045 | 0.037 | 0.015 | 0.051 | 0.000 | 0.030 | 0.000 | 0.061 | 0.034 | 0.053 |
| CityTier | 0.000 | 0.050 | 0.084 | 0.000 | 1.000 | 0.003 | 0.501 | 0.027 | 0.000 | 0.024 | 0.276 | 0.076 | 0.139 | 0.041 | 0.000 | 0.088 | 0.035 | 0.053 | 0.078 | 0.256 |
| WarehouseToHome | 0.000 | 0.128 | 0.105 | 0.060 | 0.003 | 1.000 | 0.035 | 0.016 | 0.009 | 0.031 | 0.077 | 0.000 | 0.034 | 0.022 | 0.071 | 0.087 | 0.021 | 0.020 | 0.000 | 0.065 |
| PreferredPaymentMode | 0.000 | 0.075 | 0.068 | 0.030 | 0.501 | 0.035 | 1.000 | 0.035 | 0.000 | 0.000 | 0.255 | 0.120 | 0.033 | 0.075 | 0.009 | 0.046 | 0.000 | 0.083 | 0.060 | 0.189 |
| Gender | 0.000 | 0.040 | 0.073 | 0.012 | 0.027 | 0.016 | 0.035 | 1.000 | 0.013 | 0.010 | 0.057 | 0.027 | 0.020 | 0.026 | 0.059 | 0.048 | 0.059 | 0.064 | 0.042 | 0.082 |
| HourSpendOnApp | 0.529 | 0.040 | 0.083 | 0.037 | 0.000 | 0.009 | 0.000 | 0.013 | 1.000 | 0.533 | 0.057 | 0.000 | 0.055 | 0.069 | 0.000 | 0.140 | 0.250 | 0.070 | 0.036 | 0.234 |
| NumberOfDeviceRegistered | 0.544 | 0.162 | 0.079 | 0.019 | 0.024 | 0.031 | 0.000 | 0.010 | 0.533 | 1.000 | 0.032 | 0.000 | 0.085 | 0.059 | 0.000 | 0.162 | 0.256 | 0.110 | 0.107 | 0.274 |
| PreferredOrderCat | 0.000 | 0.184 | 0.427 | 0.045 | 0.276 | 0.077 | 0.255 | 0.057 | 0.057 | 0.032 | 1.000 | 0.046 | 0.092 | 0.162 | 0.008 | 0.076 | 0.333 | 0.458 | 0.312 | 0.953 |
| SatisfactionScore | 0.543 | 0.088 | 0.060 | 0.037 | 0.076 | 0.000 | 0.120 | 0.027 | 0.000 | 0.000 | 0.046 | 1.000 | 0.300 | 0.058 | 0.035 | 0.082 | 0.032 | 0.058 | 0.045 | 0.031 |
| MaritalStatus | 0.550 | 0.110 | 0.135 | 0.015 | 0.139 | 0.034 | 0.033 | 0.020 | 0.055 | 0.085 | 0.092 | 0.300 | 1.000 | 0.078 | 0.000 | 0.000 | 0.047 | 0.064 | 0.075 | 0.111 |
| NumberOfAddress | 0.089 | 0.079 | 0.261 | 0.051 | 0.041 | 0.022 | 0.075 | 0.026 | 0.069 | 0.059 | 0.162 | 0.058 | 0.078 | 1.000 | 0.036 | 0.083 | 0.067 | 0.099 | 0.104 | 0.182 |
| Complain | 0.000 | 0.382 | 0.070 | 0.000 | 0.000 | 0.071 | 0.009 | 0.059 | 0.000 | 0.000 | 0.008 | 0.035 | 0.000 | 0.036 | 1.000 | 0.052 | 0.000 | 0.000 | 0.044 | 0.058 |
| OrderAmountHikeFromlastYear | 0.187 | 0.086 | 0.110 | 0.030 | 0.088 | 0.087 | 0.046 | 0.048 | 0.140 | 0.162 | 0.076 | 0.082 | 0.000 | 0.083 | 0.052 | 1.000 | 0.150 | 0.207 | 0.051 | 0.125 |
| CouponUsed | 0.421 | 0.026 | 0.104 | 0.000 | 0.035 | 0.021 | 0.000 | 0.059 | 0.250 | 0.256 | 0.333 | 0.032 | 0.047 | 0.067 | 0.000 | 0.150 | 1.000 | 0.778 | 0.351 | 0.365 |
| OrderCount | 0.151 | 0.076 | 0.193 | 0.061 | 0.053 | 0.020 | 0.083 | 0.064 | 0.070 | 0.110 | 0.458 | 0.058 | 0.064 | 0.099 | 0.000 | 0.207 | 0.778 | 1.000 | 0.478 | 0.434 |
| DaySinceLastOrder | 0.059 | 0.183 | 0.178 | 0.034 | 0.078 | 0.000 | 0.060 | 0.042 | 0.036 | 0.107 | 0.312 | 0.045 | 0.075 | 0.104 | 0.044 | 0.051 | 0.351 | 0.478 | 1.000 | 0.328 |
| CashbackAmount | 0.441 | 0.247 | 0.383 | 0.053 | 0.256 | 0.065 | 0.189 | 0.082 | 0.234 | 0.274 | 0.953 | 0.031 | 0.111 | 0.182 | 0.058 | 0.125 | 0.365 | 0.434 | 0.328 | 1.000 |
| Churn | CityTier | Complain | Gender | MaritalStatus | PreferredLoginDevice | PreferredOrderCat | PreferredPaymentMode | SatisfactionScore | |
|---|---|---|---|---|---|---|---|---|---|
| Churn | 1.000 | 0.083 | 0.249 | 0.026 | 0.182 | 0.049 | 0.225 | 0.092 | 0.108 |
| CityTier | 0.083 | 1.000 | 0.000 | 0.046 | 0.042 | 0.000 | 0.216 | 0.436 | 0.057 |
| Complain | 0.249 | 0.000 | 1.000 | 0.038 | 0.000 | 0.000 | 0.010 | 0.012 | 0.042 |
| Gender | 0.026 | 0.046 | 0.038 | 1.000 | 0.033 | 0.008 | 0.069 | 0.043 | 0.033 |
| MaritalStatus | 0.182 | 0.042 | 0.000 | 0.033 | 1.000 | 0.024 | 0.069 | 0.025 | 0.238 |
| PreferredLoginDevice | 0.049 | 0.000 | 0.000 | 0.008 | 0.024 | 1.000 | 0.056 | 0.037 | 0.045 |
| PreferredOrderCat | 0.225 | 0.216 | 0.010 | 0.069 | 0.069 | 0.056 | 1.000 | 0.097 | 0.017 |
| PreferredPaymentMode | 0.092 | 0.436 | 0.012 | 0.043 | 0.025 | 0.037 | 0.097 | 1.000 | 0.045 |
| SatisfactionScore | 0.108 | 0.057 | 0.042 | 0.033 | 0.238 | 0.045 | 0.017 | 0.045 | 1.000 |
A simple visualization of nullity by column.
Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.
The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.
| CustomerID | Churn | Tenure | PreferredLoginDevice | CityTier | WarehouseToHome | PreferredPaymentMode | Gender | HourSpendOnApp | NumberOfDeviceRegistered | PreferredOrderCat | SatisfactionScore | MaritalStatus | NumberOfAddress | Complain | OrderAmountHikeFromlastYear | CouponUsed | OrderCount | DaySinceLastOrder | CashbackAmount | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 50001 | 1 | 4.0 | Phone | 3 | 6.0 | Debit Card | Female | 3.0 | 3 | Laptop & Accessory | 2 | Single | 9 | 1 | 11.0 | 1.0 | 1.0 | 5.0 | 159.93 |
| 1 | 50002 | 1 | NaN | Phone | 1 | 8.0 | UPI | Male | 3.0 | 4 | Phone | 3 | Single | 7 | 1 | 15.0 | 0.0 | 1.0 | 0.0 | 120.90 |
| 2 | 50003 | 1 | NaN | Phone | 1 | 30.0 | Debit Card | Male | 2.0 | 4 | Phone | 3 | Single | 6 | 1 | 14.0 | 0.0 | 1.0 | 3.0 | 120.28 |
| 3 | 50004 | 1 | 0.0 | Phone | 3 | 15.0 | Debit Card | Male | 2.0 | 4 | Laptop & Accessory | 5 | Single | 8 | 0 | 23.0 | 0.0 | 1.0 | 3.0 | 134.07 |
| 4 | 50005 | 1 | 0.0 | Phone | 1 | 12.0 | Credit Card | Male | NaN | 3 | Phone | 5 | Single | 3 | 0 | 11.0 | 1.0 | 1.0 | 3.0 | 129.60 |
| 5 | 50006 | 1 | 0.0 | Computer | 1 | 22.0 | Debit Card | Female | 3.0 | 5 | Phone | 5 | Single | 2 | 1 | 22.0 | 4.0 | 6.0 | 7.0 | 139.19 |
| 6 | 50007 | 1 | NaN | Phone | 3 | 11.0 | Cash on Delivery | Male | 2.0 | 3 | Laptop & Accessory | 2 | Divorced | 4 | 0 | 14.0 | 0.0 | 1.0 | 0.0 | 120.86 |
| 7 | 50008 | 1 | NaN | Phone | 1 | 6.0 | Credit Card | Male | 3.0 | 3 | Phone | 2 | Divorced | 3 | 1 | 16.0 | 2.0 | 2.0 | 0.0 | 122.93 |
| 8 | 50009 | 1 | 13.0 | Phone | 3 | 9.0 | E wallet | Male | NaN | 4 | Phone | 3 | Divorced | 2 | 1 | 14.0 | 0.0 | 1.0 | 2.0 | 126.83 |
| 9 | 50010 | 1 | NaN | Phone | 1 | 31.0 | Debit Card | Male | 2.0 | 5 | Phone | 3 | Single | 2 | 0 | 12.0 | 1.0 | 1.0 | 1.0 | 122.93 |
| CustomerID | Churn | Tenure | PreferredLoginDevice | CityTier | WarehouseToHome | PreferredPaymentMode | Gender | HourSpendOnApp | NumberOfDeviceRegistered | PreferredOrderCat | SatisfactionScore | MaritalStatus | NumberOfAddress | Complain | OrderAmountHikeFromlastYear | CouponUsed | OrderCount | DaySinceLastOrder | CashbackAmount | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5620 | 55621 | 0 | 3.0 | Phone | 1 | 35.0 | Credit Card | Female | 4.0 | 5 | Phone | 5 | Single | 3 | 0 | 15.0 | 1.0 | 2.0 | 5.0 | 162.85 |
| 5621 | 55622 | 1 | 14.0 | Phone | 3 | 35.0 | E wallet | Male | 3.0 | 5 | Fashion | 5 | Married | 6 | 1 | 14.0 | 3.0 | NaN | 1.0 | 233.54 |
| 5622 | 55623 | 0 | 13.0 | Phone | 3 | 31.0 | E wallet | Female | 3.0 | 5 | Grocery | 1 | Married | 2 | 0 | 12.0 | 4.0 | NaN | 7.0 | 245.31 |
| 5623 | 55624 | 0 | 5.0 | Computer | 1 | 12.0 | Credit Card | Male | 4.0 | 4 | Laptop & Accessory | 5 | Single | 2 | 0 | 20.0 | 2.0 | 2.0 | NaN | 224.36 |
| 5624 | 55625 | 0 | 1.0 | Phone | 3 | 12.0 | UPI | Female | 2.0 | 5 | Phone | 3 | Single | 2 | 0 | 19.0 | 2.0 | 2.0 | 1.0 | 154.66 |
| 5625 | 55626 | 0 | 10.0 | Computer | 1 | 30.0 | Credit Card | Male | 3.0 | 2 | Laptop & Accessory | 1 | Married | 6 | 0 | 18.0 | 1.0 | 2.0 | 4.0 | 150.71 |
| 5626 | 55627 | 0 | 13.0 | Phone | 1 | 13.0 | Credit Card | Male | 3.0 | 5 | Fashion | 5 | Married | 6 | 0 | 16.0 | 1.0 | 2.0 | NaN | 224.91 |
| 5627 | 55628 | 0 | 1.0 | Phone | 1 | 11.0 | Debit Card | Male | 3.0 | 2 | Laptop & Accessory | 4 | Married | 3 | 1 | 21.0 | 1.0 | 2.0 | 4.0 | 186.42 |
| 5628 | 55629 | 0 | 23.0 | Computer | 3 | 9.0 | Credit Card | Male | 4.0 | 5 | Laptop & Accessory | 4 | Married | 4 | 0 | 15.0 | 2.0 | 2.0 | 9.0 | 178.90 |
| 5629 | 55630 | 0 | 8.0 | Phone | 1 | 15.0 | Credit Card | Male | 3.0 | 2 | Laptop & Accessory | 3 | Married | 4 | 0 | 13.0 | 2.0 | 2.0 | 3.0 | 169.04 |